﻿
CREATE PROCEDURE [dbo].[OPM_ReturnOrderDetail_GetModel]
(
	@Id  int
)

AS

SELECT TOP 1
	ROD.[Id],
	ROD.[ReturnOrderId],
	ROD.[ProductNumber],
	ROD.[ProductQty],
	ROD.[ReturnTypeId],
	ROD.[ReturnReasonXML],
	ROD.[OtherReasonChecked],
	ROD.[OtherReasonContent],
	ROD.[Deleted],
	ROD.[CreatedBy],
	ROD.[UpdatedBy],
	ROD.[CreatedOn],
	ROD.[UpdatedOn]
	FROM dbo.[OPM_ReturnOrderDetail] ROD 
	WHERE ROD.[Id] = @Id